CREATE TABLE `uchome_app_action` (
  `id` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `subject` VARCHAR(150) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `type_company` VARCHAR(64) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `p` VARCHAR(20) COLLATE utf8_general_ci DEFAULT '',
  `c` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `area` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `person_num` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `description` TEXT COLLATE utf8_general_ci NOT NULL,
  `eventtype` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `start_time` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `end_time` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `price_type` VARCHAR(50) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `price_description` VARCHAR(100) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `collect_area` VARCHAR(250) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `contact` VARCHAR(100) COLLATE utf8_general_ci DEFAULT '',
  `collect_type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `privite` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `picture` VARCHAR(200) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `join_num` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `interest_num` INTEGER(11) UNSIGNED NOT NULL DEFAULT '0',
  `announce` TEXT COLLATE utf8_general_ci,
  `dateline` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  KEY `p` (`p`, `c`),
  KEY `start_time` (`start_time`, `end_time`)
)ENGINE=MyISAM
AUTO_INCREMENT=6 ROW_FORMAT=DYNAMIC 
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='';

CREATE TABLE `uchome_app_action_album` (
  `pid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `title` VARCHAR(250) COLLATE utf8_general_ci DEFAULT '',
  `img` VARCHAR(250) COLLATE utf8_general_ci DEFAULT '',
  `ext` VARCHAR(5) COLLATE utf8_general_ci DEFAULT '',
  `uid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `dateline` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`pid`),
  KEY `id` (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=5 
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='InnoDB free: 9216 kB';

CREATE TABLE `uchome_app_action_invite` (
  `id` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `uid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `hash` INTEGER(10) DEFAULT '0',
  UNIQUE KEY `id` (`id`, `uid`)
)ENGINE=MyISAM
AUTO_INCREMENT=0 
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='';

CREATE TABLE `uchome_app_action_join` (
  `id` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `uid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `type` ENUM('join','interest') NOT NULL DEFAULT 'join',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `is_pass` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  UNIQUE KEY `uid` (`uid`, `id`),
  KEY `id` (`id`, `type`, `is_pass`)
)ENGINE=MyISAM
AUTO_INCREMENT=0 ROW_FORMAT=DYNAMIC 
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='';

CREATE TABLE `uchome_app_action_reply` (
  `pid` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `id` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `parentid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `dpath` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
  `uid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `message` TEXT COLLATE utf8_general_ci NOT NULL,
  `dateline` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`pid`),
  KEY `id` (`id`)
)ENGINE=MyISAM
AUTO_INCREMENT=114 ROW_FORMAT=DYNAMIC 
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='';